Generates c# classes from MS-SQL database.Each class has it's Constructors,CRUD Methods and methods fetches data according foreign keys.
DSQLT - Dynamic SQL Templates Use Stored Procedures as templates for dynamic SQL statements. Substitute parameters @0-@9 with values like objectnames or list of columnnames. Iterate over cursor-resultset instead of constant values. Write object-independent algorithms in T-SQL.
SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a SSMS Addin to bridge this gap.
FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.
The Genesis Smart Client Framework is a application development framework that allows developers to develop modules of code that is hosted inside of the framework. The framework takes care of user security, application deployment and online data access.
Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.
It's a little library to help you to alleviate some of the mundane stuff during your development. It has some nifty stuff like a neat database wrapper, conversion utilities, string functions and vast of other mini helpers to improve the efficiency and consistency of your code.
A .NET 3.5 web control that you can include in your project. This control extracts data from SQL 2008 geometry columns and draws a map image on your web page. The source download includes a Sample web page and a sample SQL 2008 database. Works in IE, FF, Opera, Chrome & Safari
This project contains Database samples released with Microsoft SQL Server product.
MY IMS CRM solution delivers a fast, flexible and familiar customer relationship management software for businesses looking to enhance their everyday productivity in the areas of sales, marketing, customer service and more. It's developed in ASP/VB.Net with SQL-Express 2008.
This project includes tools for extracting and deploying DTS (Not SSIS) packages to a SQL 2000/2005/2008 server. This is especially useful when deploying more than a couple of packages, or a SQL upgrade where DTS will still be used.
For users of MS SQL Server, xp_cmdshell is a utility that we usually want to have disabled. However there are still cases where calling a command line is needed. This project provides an framework/example to make command line calls. It is not meant as an xp_cmdshell replacement but as a workaround.
File Functions for SQL. Implemented as a SQLCLR assembly. Compatible with SQL 2008, 2008R2, and 2012. May be compatible with SQL 2005 & 2014 (untested).
This project is designed to allow inventorying and configuration management of SQL Servers in your environment. Including SQL Server configurations, databases, database configurations, database file configurations. And more.
OLAP Tools for XMLA data source * MDX Syntax, MDX DOM, MDX Parser, MDX Generator * Pivot Table on HTML5, WPF, Silverlight * Writeback supported * Report server
Parses the log files created by the Hosts Tools SQL Bandwidth Meter application
A handy application for viewing spatial data for use with SQL Server 2008. Its is very difficult to visualise a Spatial shape from a set of points, this application allows you to do that very easily. This is a windows forms application that allows you to draw shapes and obtain the spatial description for them and also enter the spatial description and have the shape displayed for you. There is a built in zoom function to zoom in on small shapes. The application also utilises the spatial data types to select shapes.
Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related services from a convenient system tray application. Please note that there is a Vista specific release as well as the standard XP/Win2003 release. There are no differences in functionality, the Vista release has just been modified to accomodate the UAC (User Account Control) feature.
a .NET application that provides realtime performance data on the target SQL Server instance. No installation required, data displayed in realtime, and can also be logged to CSV for offline analysis. Will also capture SQL data for processing uing PAL.